Eric Law
Eric Law
Reactions
-
Re: How do I add a formula to a column?
@Alia In you Subtotal High, your formula will be =Unit@row*High@row, same for the low, =Unit@row*Low@row1 · -
Re: How do I get one sheet to pull a date from another sheet?
So, to do screen shots, the shortcut is windows key+shift+s or you can just open up the snippit app in windows. If you have an apple, I can't help you there. to populate the delivery date and pickup …1 · -
Re: Sum with CountIfs
You don't need a SUM, as SUM will add what is within a cell. Just combine 2 COUNTIF formulas and you are golden, UNLESS you are only counting them if both are YES... =COUNTIF([Frame JC306395 Has Gree…1 · -
Re: Summary Sheet Formulas Corrupting when Copied
I believe the the #REF is due to the fact that you don't have a row 22. I recommend you update your formula so it can grow with your data. Try the following: =COUNTIFS([Compliance Status]:[Compliance…1 · -
Re: How to review a column of dates and count the rows that are not a date
Try this instead =COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, NOT(ISDATE(@cell)))2 ·
